package com.example.mybatis.demo.mapper;

import com.example.mybatis.demo.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: Li_yizYa
 * Date: 2025/7/15
 * Time: 16:55
 */
@Mapper
public interface ArticleInfoMapper {
    @Select("select * from article_info ta " +
            "left join user_info tb on ta.uid=tb.id " +
            "where ta.id=#{id}")
    ArticleInfo selectArticleInfoAndUserInfo(Integer id);
}
